﻿CREATE TABLE [flcr].[SERVICE_PROPERTY_TYPE] (
    [SERVICE_PROP_TYPE_ID]   INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]             VARCHAR (50)  NOT NULL,
    [AUDIT_DTTM]             DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]          INT           NOT NULL,
    [AUDIT_MOD_USER]         VARCHAR (50)  NOT NULL,
    [AUDIT_MOD_DTTM]         DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]      INT           NOT NULL,
    [BUILTIN]                BIT           NOT NULL,
    [ACTIVE_FLG]             BIT           NOT NULL,
    [SORT_ORDER]             INT           NOT NULL,
    [SERVICE_PROP_TYPE]      INT           NOT NULL,
    [SERVICE_PROP_TYPE_NAME] VARCHAR (100) NOT NULL,
    [SERVICE_PROP_TYPE_DESC] VARCHAR (250) NOT NULL,
    [PARENT_ID]              INT           NULL,
    [SERVICE_TYPE]           INT           NOT NULL
);

